﻿using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.VisualBasic;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Entity
{
    
    public class SMDBContext:DbContext
    {
        private readonly string? _ConnectionString;
        public SMDBContext (DbContextOptions<SMDBContext>opts,IConfiguration configuration) :base(opts)
        {
            _ConnectionString = configuration.GetConnectionString("AIYDB_Mysql");
        }

        DbSet<User> users { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseMySql(_ConnectionString, new MySqlServerVersion(new Version(9, 2, 0)));
        }
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.UseCollation("utf8mb4").HasCharSet("utf8mb4_german2_ci");
        }

        /// <summary>
        /// 账户
        /// </summary>
        public DbSet<Account> Account { get; set; }


        /// <summary>
        /// 用户信息
        /// </summary>
        public DbSet<User> User{ get; set; }

        /// <summary>
        /// 报名表
        /// </summary>
        public DbSet <Registration>  Registration{ get; set; }

    }
        

    
}
